﻿CREATE FUNCTION CarSoldFilter(
	@Note varchar(1024)
)RETURNS bit AS BEGIN
DECLARE @Filter varchar(512)
SET @Filter ='(Proceeds from Sale|Sale Proceeds)'

RETURN CASE WHEN dbo.clr_RegEx_Match(@Note,@Filter,1) > '' THEN 1 ELSE 0 END

END